DROP TABLE IF EXISTS `db_dic_type`;
CREATE TABLE IF NOT EXISTS `db_dic_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(16) NOT NULL,
  `code` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `db_dic`;
CREATE TABLE IF NOT EXISTS `db_dic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dicid` int(11) NOT NULL,
  `name` varchar(16) NOT NULL,
  `value` varchar(16) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;